Skip to main content

WINDOW SORT

Short Description

Analytical WINDOW functions are applying a sort order to data.

Detailed Description​

A sort order is applied to an analytical WINDOW function - OVER [PARTITION BY] [ORDER BY], data will be sorted before being passed on to the next plan execution step.

For example:

SELECT
    id
   ,s_3000
   ,LEAD(id) OVER (partition by s_3000 order by id)
  FROM t49_53268
 WHERE s_3000 = 1778;

Further Reading​

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.